package com.huli.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.huli.domain.PlatformIncome;
import com.huli.dto.PlatformIncomeDto;
import com.huli.param.PlatformIncomeParam;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface PlatformIncomeMapper extends BaseMapper<PlatformIncome> {

    //查询平台日收入
    @Select("SELECT YEAR(platform_income_time) year,MONTH(platform_income_time) month,DAY(platform_income_time) day,platform_income_money FROM platform_income" +
            " WHERE YEAR(platform_income_time)=#{year} " +
            "AND MONTH(platform_income_time)=#{month} " +
            "AND DAY(platform_income_time)=#{day}")
    public PlatformIncomeDto selectPlatformIncome(PlatformIncomeParam platformIncomeParam);
}
